﻿CREATE TABLE spm.EventLog
(
	/*
	 * Table to capture logging information from the SSAS Partition Manager.
	 * This table is only used when the ADONetAppender_SqlServer appender is enabled in the .config file
     *
	 * Part of the SSAS Partition Manager sample code which can be downloaded from https://SsasPartitionManager.codeplex.com/
	 * 
	 * Written by Dr. John Tunnicliffe, independent business intelligence consultant
	 * eMail: john@decision-analytics.co.uk 
	 * http://www.decision-analytics.co.uk/
	 * https://www.linkedin.com/in/drjohntunnicliffe
	 */
	EventLogId int identity(-2147483648,1) not null PRIMARY KEY,
	LogTime datetime,
	Thread nvarchar(10),
	LogLevel nvarchar(10),
	Logger nvarchar(255),
	LogMessage nvarchar(4000)
);
GO

